select * from products where pro_name like '%Quinceanera%dress%with%tail%' or pro_des like '%Quinceanera%dress%with%tail%'union all select * from products where (pro_name like '%Quinceanera%' or pro_des like '%Quinceanera%') or(pro_name like '%dress%' or pro_des like '%dress%') or(pro_name like '%tail%' or pro_des like '%tail%') and (pro_name not like '%Quinceanera%dress%with%tail%' or pro_des not like '%Quinceanera%dress%with%tail%')

Gorgeous Sea Green Sweetheart Chapel Train Beading Quinceanea Dress

Sweetheart Taffeta Beading and Embroidery Blue Quince Dresses

Modest Purple Sweetheart Appliques Quinceanera Gown with Jacket

Taffeta and Tulle Quince Dress in Teal and White with Floor-length

Multi-color Sweetheart Sweet 15th Dress with Ruffles and Appliques

White and Olive Green Ball Gown Quince Dress in Taffeta and Tulle

Ball Gown Dress Quinces with Embroidery in White and Turquoise

Sweetheart Beaded Quinces Dress in Light Blue with Tulle Fabric

Green and Black Quinceanera Dress with V-neck Straps and Beading

Lilac Quinceanera Gown with Organza Ruffles and Appliques

Beaded Strapless Ball Gown Dress for Quinces with Floor-length

Royal Blue and Black Beaded Quince Dress with Tulle and Taffeta

Colorful Strapless Quinceanera Gown with Beading and Ruffles

White and Fuchsia Quinceanera Dress with Embroidery in Satin

Embroidered Quinces Dress with Bubble Sleeves and Floor-length

Taffeta Embroidered Dresses for Quinceanera in Purple Ball Gown

Ball Gown Floor-length Dress for Quince with Beads in Dark Purple

White and Apple Green Dress for Quinceanera Party with Appliques

Hot Pink Ball Gown Dress for 16th with Sweetheart-neck and Ruche

Ball Gown Dress for Quinceanera with Jacket and Appliques

Ball Gown Appliqued Quinces Dress with Floor-length in Coral Red

Fitted Strapless Organza Quinces Dress with Appliques in Green

Orange Red and Yellow Quinces Gown with Appliques and Beading

Embroidery with Beading 15th Dress in Blue and Black Sweetheart

Orange Strapless Quince Dress with Organza Ruffles and Appliques

Organza Ruffles Sweet 15th Dress in Dark Purple with Sweetheart for Miss World Competition

Floor-length Sweet Sixteenth Dresses with Appliques in Wine Red

Olive Ball Gown Quinces Dress with Sweetheart and Appliques

Strapless Yellow Green Quinces Dress in Taffeta with Beading

Taffeta Strapless Sweet 15th Dress with Beads in Spring Green